﻿--2012年12月
alter table SysUser
add AllowAllCompany bit not null default 0
go

alter table SysUser
add CompanyName nvarchar(max)
go

alter table Staff
add BirthDay datetime not null default '1900-01-01'
go
--2013年1月5日
alter table billing 
add ContractNo nvarchar(max) null
go

alter table billing 
add HasDeleted bit not null default(0)
go

---------2013.1.7

CREATE TABLE [dbo].[UserReport](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[ReportName] [nvarchar](256) NULL,
	[ReportSql] [nvarchar](max) NULL,
 CONSTRAINT [PK_UserReport] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

------2013.3.3  门票家数
alter table Billing 
add MenPiaoCount float not null default(0)